import pandas as pd

xlsxpath = r'./resouse/events.xlsx'

#waytag读取
def input_waytag():
    path = r'./resouse/events.xlsx'#skiprows跳过几行，nrows读取几行，去掉就是全部读取
    df=pd.read_excel(path,skiprows=1,nrows=5,sheet_name="tags")

    data = df.values.tolist()
    result = []
    for s_li in data:
        #print(s_li)
        result.append(s_li)
    #print(result)
    return result

#初始tag读取
def input_initTag():
    path = r'./resouse/events.xlsx'#skiprows跳过几行，nrows读取几行，去掉就是全部读取
    df=pd.read_excel(path,skiprows=6,nrows=33,sheet_name="tags")

    data = df.values.tolist()
    result = []
    for s_li in data:
        #print(s_li)
        result.append(s_li)
    #print(result)
    return result

#标准tag读取
def input_tag():
    path = r'./resouse/events.xlsx'#skiprows跳过几行，nrows读取几行，去掉就是全部读取
    df=pd.read_excel(path,sheet_name="tags")

    data = df.values.tolist()
    result = []
    for s_li in data:
        #print(s_li)
        result.append(s_li)
    #print(result)
    return result

#事件列表读取
def input_events():
    path = r'./resouse/events.xlsx'#skiprows跳过几行，nrows读取几行，去掉就是全部读取
    df=pd.read_excel(path,skiprows=0,sheet_name="events")

    data = df.values.tolist()
    result = []
    for s_li in data:
        #print(s_li)
        result.append(s_li)
    #print(result)
    return result

InitTag=input_initTag()#初始tag读取
WayTag=input_waytag()#way tag读取
Tag=input_tag()#tag读取
Events=input_events()#events读取


